<%@ page contentType="text/html;charset=UTF-8"%>
<% //@include file="../../common/sessionValidate.jsp" %>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML>
<html lang="UTF-8">
<head>
    <title>库存管理->库存导入上传</title>
    <%@ include file="../../common/meta.jsp"%>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta http-equiv="X-UA-Compatible" content="IE=9">
    <META HTTP-EQUIV="Cache-Control" CONTENT="no-cache, must-revalidate">
    <link rel="stylesheet" href="<%=basePath%>css/my-bootstrap.css" media="screen"  id="tuserskin">
    <link rel="stylesheet" href="<%=basePath%>js/toastr/toastr.css">
    <link rel="stylesheet" href="<%=basePath%>css/bootstrapValidator.min.css">
    <link rel="stylesheet" href="<%=basePath%>css/font-awesome.min.css">
    <script type="text/javascript" src="<%= basePath %>js/jquery.cookie.js"></script>
</head>
<style>
    hr {
        margin-top:1px;
        border-bottom: 1px solid #1BBC9B;
    }
</style>
<body>
<div class="" style="margin-right:2px;padding-right:1px;">

    <!--------------------------查询条件表格  start------------------------------->

    <!-- 查询面板 -->
    <div class="panel panel-primary" id="cxDiv">
        <!-- Default panel contents -->
        <form class="form-horizontal" name="form1" id="form1">
        <div class="panel-heading  " >
            <i class='icon-filter'></i>&nbsp;库存批量导入

            <span class="text-right pull-right">
        	<button type="button" class=" btn btn-success btn-xs img-rounded"  onclick="Search(0)"><i class="icon-search"></i>&nbsp;查询</button>&nbsp;
            <button type="reset" class=" btn btn-success btn-xs img-rounded"  > <span class="icon-retweet"></span>&nbsp;重置</button>&nbsp;
            <button type="button" class=" btn btn-success btn-xs img-rounded" id="shButton" >&nbsp;<span id="qhDiv" class="icon-chevron-up"></span>&nbsp;</button>
            <!--<input type="hidden" name="status" id="status" value="1">-->
                <input type="hidden" name="kucuntype" id="kucuntype" value="wuye">
        </span>
        </div>
        </form>
        <div class="panel-body" id="shDiv" class="panel-collapse collapse in">

            <form name="ffAdd" id="ffAdd" target=""  enctype="multipart/form-data" method="post"  >
                <div class="col-xs-6">
                    <div class="form-group">
                        <label class="control-label col-xs-5">库存文件上传批量导入(.xls结尾的Excel文件)</label>
                        <div class="col-xs-7" align="left" style="border: 1px;">
                            <input type="file"  style=" border: 1px; border-color: #2a85a0" id="upOrderfile" name="upOrderfile">
                            <iframe style="display: none" name="hide_iframe" id="hide_iframe"></iframe>
                        </div>
                    </div>
                </div>
                <div class="col-xs-3">
                    <div class="form-group">
                        <label class="control-label col-xs-3" style="">
                            <input type="button"  id="sb" value="提交库存数据文件" name="sb"  onclick="add()" >
                        </label>
                        <div class="col-xs-7">

                        </div>
                    </div>
                </div>
                <div class="col-xs-3">
                    <div class="form-group">
                        <label class="control-label col-xs-5"> </label>
                        <div class="col-xs-7">
                        </div>
                    </div>
                </div>

            </form>

        </div>
    </div>

    <!--------------------------查询条件表格end------------------------------------->

    <!--------------------------信息列表：带表格面板  start--------------------------------->
    <div class="panel panel-primary">
        <div class="panel-heading clearfix" >
            <i class='icon-reorder'></i>&nbsp; 数据列表
            <span class="text-right pull-right ">
            <!-- -->
            <a href="<%=basePath%>t_order_goods/toT_order_goodsKucunCurd?oplx=add" class="text-danger"><i class='icon-plus'></i>&nbsp;新增</a>&nbsp;&nbsp;&nbsp;&nbsp;
            <a href="#" onclick="toEdits()" class="text-danger"><i class='icon-pencil'>&nbsp;修改</i></a>&nbsp;&nbsp;&nbsp;&nbsp;
            <a href="#" onclick="toViews()"  class="text-danger"><i class='icon-table'></i>&nbsp;查看</a>&nbsp;&nbsp;&nbsp;&nbsp;

            <a href="#" onclick="getDel()" class="text-danger"><i class='icon-minus'></i>&nbsp;删除</a>&nbsp;&nbsp;&nbsp;&nbsp;
            <a href="#" onclick="Search(0)" class="text-danger btn-sm"><i class='icon-refresh'></i>&nbsp;刷新</a>&nbsp;&nbsp;
            <a href="#" onclick="showOrHidden()" class="text-danger btn-sm"><span id="fsDiv" class='glyphicon glyphicon-resize-full'></span></a>
	     </span>
        </div>
        <div class="panel-body">
            <p>每页显示<select id="pageSize" class=" label-primary" onchange="Search(0)">
                <option value="10" >10</option>
                <option value="20">20</option>
                <option value="30">30</option>
                <option value="50" selected>50</option>
                <option value="100" >100</option>
            </select>条记录，&nbsp;&nbsp;&nbsp;&nbsp;共有记录：<span id="totalCount" class="label label-primary">0</span> 条，总页数：<span id="totalPageNo" class="label label-primary">0</span>页。
            </p>
            <table id="grid" class="table table-condensed table-striped table-bordered table-hover" class="sortable" cellpadding="0" cellspacing="0" border="0" class="display" width="100%">
                <thead id="grid_head">
                <tr>
                    <!---->
                    <th onclick="" class="table-checkbox" ><input class="group-checkable" name="batchSelectedAll" id="batchSelectedAll" type="checkbox" onclick="selectAll()"></th>

                    <!-- <th onclick="sortTableT.sort('grid',0,'String')"> 序号</th> -->
                    <th onclick="sortTableT.sort('grid',0,'String')">仓库</th>
                    <th onclick="sortTableT.sort('grid',0,'String')">类别</th>
                    <th onclick="sortTableT.sort('grid',0,'String')">名称/编号</th>
                    <th onclick="sortTableT.sort('grid',0,'String')">规格型号</th>

                    <th onclick="sortTableT.sort('grid',0,'String')">库存数量</th>
                    <th onclick="sortTableT.sort('grid',0,'String')">单位</th>
                    <th onclick="sortTableT.sort('grid',0,'String')">供应商</th>
                    <!-- <th onclick="sortTableT.sort('grid',0,'String')"> 盘数</th> -->
                    <th onclick="sortTableT.sort('grid',0,'String')"> 批次号</th>

                    <th onclick="sortTableT.sort('grid',0,'String')"> 入库者</th>
                    <th onclick="sortTableT.sort('grid',0,'String')"> 入库时间</th>
                    <th onclick="sortTableT.sort('grid',0,'String')"> 状态</th>
                    <th style="width:50px">操作</th>
                </tr>
                </thead>
                <tbody id="grid_body"></tbody>
            </table>
            <div>

            </div>
            <div class="paging-toolbar">
                <ul class="pager" style='margin-bottom:5px;' id='grid_paging'></ul>
            </div>
        </div>
    </div>
    <!--------------------------信息列表：带表格面板 end------------------------------------>

</div>
</body>
</html>

<script src="<%=basePath%>js/bootstrap.min.js"></script>
<!--<script src="<%=basePath%>js/jquery-1.10.2/jquery.min.js"></script>
<script type="text/javascript" src="js/bootstrapValidator.js"></script>-->
<script src="<%=basePath%>js/bootstrap-paginator.min.js"></script>
<script src="<%=basePath%>/js/respond.js"></script>
<script src="<%=basePath%>/js/html5.js"></script>
<script src="<%=basePath%>js/toastr/toastr.js"></script>
<script src="<%=basePath%>js/bootbox.js"></script>
<script src="<%=basePath%>js/jquery.validate.js"></script>
<!-- <script src="<%=basePath%>js/additional-methods.min.js"></script> -->
<script src="<%=basePath%>js/my-jquery-curd.js"></script>
<script src="<%= basePath %>js/tableSortTool.js" ></script>
<script src="<%= basePath %>js/calendar.js" ></script>
<!-- 禁止右键刷新 -->
<script src="<%= basePath %>js/jinzhishuaxin.js" ></script>

<script type="text/javascript">
    var flag = "<%= request.getParameter("flag") %>";

    //新增保存数据
    function add() {
        var upOrderfile = $("#upOrderfile").val();
        if(upOrderfile==""||upOrderfile==null){
            alert("文件不能为空，请选择文件！");
            $("#upOrderfile").focus();
            return false;
        }
        //判断是否为.xls文件；
        var filesuf= upOrderfile.substring(upOrderfile.lastIndexOf(".")+1);
        //alert(filesuf); //如：txt
        if(filesuf!=="xls"){
            alert("选择的上传库存文件必须是以'.xls'结尾的Excel格式文件！");
            $("#upOrderfile").focus();
            return false;
        }

        //$("#addSaveButton").attr("disabled", true);
        var url = "<%=basePath%>t_order_goods/excelKucunUpload?1=1&time="+Math.random();
        //直接提交表单；jquery $.ajax和$.post不能提交file的
        //你可以在页bai面放一个隐藏的iframe 然后du让表单提zhi交到这个iframe
        //alert("url="+url);
        ffAdd.action =  url;
        ffAdd.submit();
        //$("#upOrderfile").val("");

    }

    $().ready(function(){
        //1、初始化数据显示
        Search(0);

        //2、隐藏或者显示
        $("#shButton").click(function(){
            $("#shDiv").toggle();
            $("#qhDiv").toggleClass("icon-chevron-up icon-chevron-down");
        });

    }) //end funciton read;

    //根据查询条件，查询列表数据并显示
    function Search(startIndex){
        //判断是否是提交后返回到自身页面；
        //result就是提bai交以后的返回值
        //$('#hide_iframe').load(function(){
        //alert("result"+ $(this).contents().find("body").text());
        //var result = $(this).contents().find("body").text();

        var resultString = "<%= request.getAttribute("resultString") %>";
        //alert("flag="+flag+";返回字符串时 resultString="+resultString+";type of resultString="+ typeof resultString);
        //alert("resultString === null?"+ resultString===null);
        if(flag !== "1"){ //当flag=="1"时，说明是从左侧菜单跳转过来的，如果是没值，说明是从controller跳过来的；
            //alert("返回字符串时 resultString="+resultString);
            //alert("result typeof ="+typeof result +";result="+result+";======result.result="+result.result);
            //返回字符串时用如下方案
            if (resultString=="success") {
                //保存成功  1.关闭弹出层，
                flag = "1";
                showSuccessTips("恭喜保存成功!", "提示");
            }
            else {
                showErrorTips("保存数据失败!", "错误信息："+resultString);
            }
        }

        //执行正常的业务加载；
        var pageSize = document.getElementById("pageSize").value;
        var condition = $("#form1").serialize();
        var url = "<%=basePath%>t_order_goods/getAllT_order_goods?startIndex="+startIndex+"&pageSize="+pageSize+"&"+condition+"&time="+Math.random();
        //alert(url);
        $.getJSON(url, function (data){
            //$("#pageSize").html(data.pageSize);
            $("#totalCount").html(data.totalCount);
            $("#totalPageNo").html(data.totalPageNo);
            $("#grid_body").html("");

            //1、表格行内容输出
            $.each(data.items, function(i,item){
                var str="<tr>";
                str+="<td><input class='checkboxes' name='batchSelected' id='batchSelected' type='checkbox' value='"+item.order_goods_id+"'></td>";
                //str+="<td>"+(i+1)+"</td>";
                str+="<td>"+doNull(item.buyer_company_name)+"</td>";
                str+="<td>"+doNull(item.saller_tel)+"</td>";
                str+="<td>"+doNull(item.buyer_tel)+"</td>";
                str+="<td>"+doNull(item.saller_company_address)+"</td>";

                str+="<td>"+doNull(item.good_num)+"</td>";
                str+="<td>"+doNull(item.ext2)+"</td>";
                str+="<td>"+doNull(item.saller_company_name)+"</td>";
                //str+="<td>"+doNull(item.good_num)+"</td>";
                str+="<td>"+doNull(item.ext1)+"</td>";

                str+="<td>"+doNull(item.creater)+"</td>";
                str+="<td>"+doNull(item.creattime)+"</td>";
                if(item.status==0){
                    str+="<td><span class='label label-primary'>未生效</span></td>";
                }else if(item.status==1){
                    str+="<td><span class='label label-success'>已生效</span></td>";
                }else{
                    str+="<td><span class='label label-danger'>其它状态</span></td>";
                }
                str+="<td>&nbsp;&nbsp;";
                str+="<a href='<%=basePath%>t_order_goods/toT_order_goodsKucunCurd?oplx=view&id="+item.order_goods_id+"&time="+Math.random()+"' class='text-danger'>&nbsp;&nbsp;<span class='glyphicon glyphicon-search' style='color:rgb(0, 128, 255)'></span>&nbsp;&nbsp;</a>";
                str+="<a href='<%=basePath%>t_order_goods/toT_order_goodsKucunCurd?oplx=edit&id="+item.order_goods_id+"&time="+Math.random()+"' class='text-danger'>&nbsp;&nbsp;<span class='icon-pencil'  style='color:rgb(0, 128, 255)'></span>&nbsp;&nbsp;</a>";
                str+="<a href='javascript:del("+item.order_goods_id+")' class='text-danger'>&nbsp;&nbsp;<span class='icon-remove' style='color:rgb(0, 128, 255)'></span></a>&nbsp;&nbsp;";

                str+="</td>";
                str+="</tr>";
                $("#grid_body").append(str);
            });//end each data;

            //2、分业处理
            var element = $("#grid_paging");
            if(data.totalCount>0){
                //第二种处理分页方案，直接生成分页html内容，然后.html()到目标对象；
                var pageHtml ="";
                pageHtml +='<li><button type="button" class=" btn btn-primary btn-sm " onclick="Search('+data.firstIndex+')">首页</button></li>';
                pageHtml +='<li><button type="button" class=" btn btn-primary btn-sm " onclick="Search('+data.previousIndex+')">上一页</button></li>';
                pageHtml +='<li><button type="button" class=" btn btn-primary btn-sm " >当前第  '+data.currentPageNo+' 页</button></li>';
                pageHtml +='<li><button type="button" class=" btn btn-primary btn-sm " onclick="Search('+data.nextIndex+')">下一页</button></li>';
                pageHtml +='<li><button type="button" class=" btn btn-primary btn-sm " onclick="Search('+data.lastIndex+')">尾页</button></li>';
                element.html(pageHtml);
            }else{
                element.html("");
            }
        })//end getJSON;
    }

    //通过选择单条记录，点击‘修改‘按钮进行查看
    function toEdits(){
        var id = checkfunctionIDS(); //如果选择多条记录，则提示请选择一条记录。
        if(id!=false){
            self.location= "<%=basePath%>t_order_goods/toT_order_goodsKucunCurd?oplx=edit&id="+id+"&time="+Math.random();
        }
    }

    //通过选择单条记录，点击‘查看‘按钮进行查看
    function toViews(){
        var id = checkfunctionIDS(); //如果选择多条记录，则提示请选择一条记录。
        if(id!=false){
            self.location= "<%=basePath%>t_order_goods/toT_order_goodsKucunCurd?oplx=view&id="+id+"&time="+Math.random();;
        }
    }

    //通过选择单条记录，点击‘删除‘按钮进行查看
    function getDel(){
        var id = checkfunctionIDS(); //如果选择多条记录，则提示请选择一条记录。
        if(id!=false){
            del(id);
        }
    }

    //删除函数
    function del(id){
        var url = "<%=basePath%>t_order_goods/delT_order_goods?id=" + id+"&time="+Math.random();
        bootbox.confirm({
            size: 'small',
            buttons: {
                confirm: {
                    label: ' 删除 ',
                    className: 'btn btn-sm btn-danger'
                },
                cancel: {
                    label: '   取消     ',
                    className: 'btn btn-success btn-sm'
                }
            },
            message: '您确认要删除选中的记录？',
            callback: function(result) {
                if(result) {if(result){ myDel(url);}}
            },
            title:'删除记录提示：',
            className:' '
        })
    }
</script>